//package com.preparation.mapper;
//
//import com.baomidou.mybatisplus.core.mapper.BaseMapper;
//import com.preparation.domain.VideoSet;
//import com.preparation.dto.CascadeNodeDto;
//import org.apache.ibatis.annotations.Mapper;
//import org.apache.ibatis.annotations.Select;
//
//import java.util.List;
//
//@Mapper
//public interface VideoSetMapper extends BaseMapper<VideoSet> {
//
//    //获取级联数据列表  根据类别id查询
//    @Select("select id as value,set_title as label from tbl_video_set where category_id=#{categoryId}")
//    List<CascadeNodeDto> getCascadeData(Integer categoryId);
//
//    //根据类别id查询所有合集
//    @Select("select vs.*,c.category_name from tbl_video_set vs " +
//            "inner join tbl_category c on c.id=vs.category_id " +
//            "where category_id=#{categoryId} " +
//            "order by vs.number ASC")
//    List<VideoSet> getByCid(Integer categoryId);
//}
